play makAll work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All HBAM2016AUG95 Pro 3.0 All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dullCopyright 1984-1996 Claris Corporation and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. mark@ HBAM3016AUG95@ brandon james johnB markB Pro 3.0F! Sunday Monday Tuesday Wednesday Thursday Friday Saturday January February March April August September October November December 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Helvetica Geneva 1/27/97 CONSTANT FIRST NAME LAST NAME SEARCH FIELD SEARCH STORED SEARCH VALUE STATE ZIP CODE First NameB A Last NameB Zip CodeB StateB ConstantB Search FieldB Search ValueB Search StoredB Search StoredB Helvetica Geneva First NameH A Layout #1 A Layout #2 A Layout #2 ayout #2 First NameD Last NameF StateH Zip CodeM'Basic Contacts Demo file for SEARCH.FP3N SearchO Click the search button, enter your request and watch the magic happen. You could hook this premade solution up to your database within 30 minutes.P6Click here to find out how to connect to your databaseQ Find AllRBTIP: Try drag-n-drop for finding things using the search database.S LEGAL: This technique and file are (c) 1997 by ISO Productions / Matt Petrowsky. Commercial reproduction and use allowed only by license. Personal and Private use are free from license and or payment fees. Helvetica Geneva A Layout #2B type Text 3. Create a calculation field named Constant with a result of 1 What you must do to the SEARCH.FP3 database.... 1. Create a relationship based on Constant 2. Set your specific search fields in Step 2 of SEARCH.FP3 C More Info "You must duplicate the steps below 'into your own database. Their steps can "be printed by printing the scripts from the print dialog. Search Button ------ SEARCH ROUTINE ------ Run Search Routine ( Step 1: Build Search from Global Copy # Part A: Get Top Search String Part B: Set Search Values ) Part C: Strip off top search string A"You must duplicate the steps below Helvetica Geneva Arial A'into your own database. Their steps can A"be printed by printing the scripts from the print dialog. Search Button AiWhen a user clicks on the search button it prompts the search file to open up and run its opening script. Helvetica Geneva Arial Run Search Routine A( Step 1: Build Search from Global Copy = "" A# Part A: Get Top Search String 1) - 1) ") = 0 1) + 1 99999999) 1) + 1 1) - 1) - 1) 1RPTH FPTHA1Power World:Desktop Folder:19:19 FINAL:SEARCH.FP3 MSPCA NAMEA SEARCH.FP3 RPTHA SEARCH.FP3 alisA Power World d_)BD SEARCH.FP3 FMP3FMP3 19 FINAL 1Power World:Desktop Folder:19:19 FINAL:SEARCH.FP3 ------ SEARCH ROUTINE ------ Helvetica Geneva Arial Helvetica Geneva Arial A Layout #1B MattB PetrowskyC 98465D A John MarkB OsborneC 54165D CusickC 87946D JoelB BowersC 98568D VinceB MennanoC 65483D TonyB RobinsC 98745D MickeyB MouseC 65716D JoeiB RobinsonC 35451D MinmeiB PetrowskyC 98468D JamesB FortierC 67486D JohnB KrischeC 54613D BrandonB PetrowskyC 57654D What you must do to your database.... 1. Create a global field called Search Field of type Text 2. Create a global field called Search Value of type Text 3. Create a global field called Search Stored of type Text 4. Create a calculation field named Constant with a result of 1 5. Duplicate the Search Routine scripts (found here) in your database and copy and paste the formulas from here If you have questions please review the fields defined in this database and duplicate them in your own. on in SEARCH.FP3 to call the Run Search Routine in your database equests to My Database script in SEARCH.FP3 4. Edit the Perform Find button in SEARCH.FP3 to call the Run Search Routine in your database Part B: Set Search Values ps are basically the same. All you need to do is duplicate one for each field that you will be using to search on. This script will cycle through the field and if there is value in them already it will be skipped, if not then the search value is used. This can be extended to account for multiple requests on the same field but we have not shown that here. = "First Name" First Name = "Last Name" Last Name = "State" State = "Zip" A) Part C: Strip off top search string ") = 0 1) + 1 99999999) uplicate one for each field that you will be using to search on. This script will cycle through the field and if there is value in them already it will be skipped, if not then the search value is used. This can be extended to account for multiple requests on the same field but we have not shown that here. = "First Name" First Name = "Last Name" Last Name = "State" State tAll of these steps are basically the same. All you need to do is duplicate one for each field that you will be using to search on. This script will cycle through the field and if there is value in them already it will be skipped, if not then the search value is used. This can be extended to account for multiple requests on the same field but we have not shown that here. = "First Name" First Name = "Last Name" Last Name = "State" State = "Zip" ) = 0 Cancel oThere were no records found that match your search criteria. = "" A# Part A: Get Top Search String 1) - 1) ") = 0 1) + 1 99999999) 1) + 1 1) - 1) - 1) A( Step 1: Build Search from Global Copy = "" A# Part A: Get Top Search String 1) - 1) ") = 0 1) + 1 99999999) 1) + 1 1) - 1) - 1) ReturnD Setting up the SEARCH.FP3 database should take about 15-30 minutes and is well worth it. Play around with this example to see how powerful it is.E`Print the scripts in this database and duplicate them in your own. But first follow these steps.ound with this example to see how powerful it is. markB mickey minmei vince bowers cusick fortier krische mennano mouse osborne petrowsky robins robinson 35451 54165 54613 57654 65483 65716 67486 87946 98465 98468 98568 98745 Sunday Monday Tuesday Wednesday Thursday Friday Saturday January February March April August September October November December 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Pro 3.0F! Sunday Monday Tuesday Wednesday Thursday Friday Saturday January February March April August September October November December 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 9What you must do to the SEARCH.FP3 database.... 1. Create a relationship based on Constant 2. Set your specific search fields in Step 2 of SEARCH.FP3 3. Edit the Send Search Requests to My Database script in SEARCH.FP3 4. Edit the Perform Find button in SEARCH.FP3 to call the Run Search Routine in your database